<?php
/**
 * ShopEx licence
 *
 * @copyright  Copyright (c) 2005-2010 ShopEx Technologies Inc. (http://www.shopex.cn)
 * @license  http://ecos.shopex.cn/ ShopEx License
 */

$db['brand']=array (
  'columns' =>
  array ( 
    'brand_id' =>
    array (
      'type' => 'number',
      'required' => true,
      'pkey' => true,
      'extra' => 'auto_increment',
      'label' => app::get('b2c')->_('品牌id'),
      'width' => 150,
      'comment' => app::get('b2c')->_('品牌id'),
      'editable' => false,
      'in_list' => true,
      'default_in_list' => true,
        'orderby' => true,
        'order_field' => 'brand_id',
    ),
	'crm_code'=>array (
      'type' => 'varchar(32)',
      'label' => app::get('b2c')->_('CRM客户编码'),
      'width' => 150,
      'comment' => app::get('b2c')->_('CRM对接预留字段'),
    ),
    'brand_name' =>
    array (
      'type' => 'varchar(50)',
      'label' => app::get('b2c')->_('品牌名称'),
      'width' => 180,
      'is_title' => true,
      'required' => true,
      'comment' => app::get('b2c')->_('品牌名称'),
      'editable' => true,
      'searchtype' => 'has',
      'in_list' => true,
      'default_in_list' => true,
      'orderby' => true,
    ),
	'brand_logo' =>
    array (
      'type' => 'varchar(255)',
      'comment' => app::get('b2c')->_('品牌logo'),
      'editable' => false,
      'label' => app::get('b2c')->_('品牌图片标识'),
     'in_list' => false,
      'default_in_list' => false,
    ),
	'brand_ad' =>
    array (
      'type' => 'varchar(255)',
      'comment' => app::get('b2c')->_('广告图'),
      'editable' => false,
      'label' => app::get('b2c')->_('品牌广告图'),
     'in_list' => false,
      'default_in_list' => false,
    ),
    'brand_url' =>
    array (
      'type' => 'varchar(255)',
      'label' => app::get('b2c')->_('品牌网址'),
      'width' => 350,
      'comment' => app::get('b2c')->_('品牌网址'),
      'editable' => true,
      'searchtype' => 'has',
      'in_list' => true,
      'default_in_list' => true,
    ),
    'brand_desc' =>
    array (
      'type' => 'longtext',
      'comment' => app::get('b2c')->_('品牌介绍'),
      'editable' => false,
      'label' => app::get('b2c')->_('品牌介绍'),
    ),
	'brand_intro' =>
    array (
      'type' => 'text',
      'comment' => app::get('b2c')->_('brand intro'),
      'editable' => true,
      'label' => app::get('b2c')->_('brand intro'),
	  'in_list' => true,
      'default_in_list' => true
    ),
    
    'brand_keywords' =>
    array (
      'type' => 'longtext',
      'label' => app::get('b2c')->_('品牌别名'),
      'width' => 150,
      'comment' => app::get('b2c')->_('品牌别名'),
      'editable' => false,
      'searchtype' => 'has',
       'in_list' => true,
      'default_in_list' => true,
    ),
    'brand_setting' =>
    array(
        'type' => 'serialize',
        'label' => app::get('b2c')->_('品牌设置'),
        'deny_export' => true,
    ),
    'disabled' =>
    array (
      'type' => 'bool',
      'default' => 'false',
      'comment' => app::get('b2c')->_('失效'),
      'editable' => false,
      'label' => app::get('b2c')->_('失效'),
      'in_list' => false,
      'deny_export' => true,
    ),
    'ordernum' =>
    array (
      'type' => 'number',
      'label' => app::get('b2c')->_('排序'),
      'width' => 150,
      'comment' => app::get('b2c')->_('排序'),
      'editable' => true,
      'in_list' => true,
    ),
	'register_time'=>
	array (
      'type' => 'int(10)',
	  'type' => 'time',
      'label' => app::get('b2c')->_('注册时间'),
      'width' => 110,
      'editable' => false,
      'in_list' => true,
    ),
	'register_opera'=>
	array (
      'type' => 'varchar(255)',
      'label' => app::get('b2c')->_('注册公司'),
      'editable' => false,
      'in_list' => true,
    ),
	'sto_confirm'=>
	array (
      'type' => 
      array (
        'Y' => app::get('b2c')->_('需确认'),
        'N' => app::get('b2c')->_('无需确认'),
      ),
	  'default'=>'Y',
      'label' => app::get('b2c')->_('供应商库存确认'),
      'editable' => false,
      'in_list' => true,
	  'filtertype' => 'yes',
	  'filterdefault' => true,
    ),
	'rebate'=>
	array (
      'type' => 'decimal(20,3)',
      'default'=>'10',
      'label' => app::get('b2c')->_('返点比例'),
      'editable' => false,
      'in_list' => true,
    ),
	'has_bind'=>
	array (
	'type' => 
      array (
        'Y' => app::get('b2c')->_('已关联'),
        'N' => app::get('b2c')->_('未关联'),
      ),
	  'default'=>'N',
      'label' => app::get('b2c')->_('是否关联供应商'),
      'in_list' => true,
    ),
	'account_mode'=>
	array (
	'type' => 
      array (
        'rebate' => app::get('b2c')->_('返点'),
        'account' => app::get('b2c')->_('结算价'),
        'freeprice' => app::get('b2c')->_('自由定价'),
      ),
	  'default'=>'rebate',
      'label' => app::get('b2c')->_('结算方式'),
      'in_list' => true,
    ),
  ),
  'index' =>
  array (
    'ind_disabled' =>
    array (
      'columns' =>
      array (
        0 => 'disabled',
      ),
    ),
    'ind_ordernum' =>
    array (
      'columns' =>
      array (
        0 => 'ordernum',
      ),
    ),
  'ind_brand' =>
      array (
          'columns' =>
              array (
                  0 => 'brand_id',
              ),
      ),
  ),
  'version' => '$Rev: 40654 $',
  'comment' => app::get('b2c')->_('商品品牌表'),
);
